<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<html>
                <head>
        <title>Cancion</title>
        <link rel="stylesheet" href="resources/style.css" type="text/css" />
        <script type="text/javascript" src="resources/mtmtrack.js"></script>
    </head>
    <body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
        <div id="Imeca368fm1130a6e1a2amm7cea">
        <a id="Imeca368fm1130a6e1a2amm7cea"/>
            



            <p></p>
    <br/>
<h2>Class Cancion</h2>
<!-- ================================== INHERITANCE ================================= -->
    
<dl>


</dl>
<hr/>
<dl>
<dt>

<!-- ==================================== SIGNATURE ================================== -->
    public class <b>Cancion</b>

        <!-- parent rendering -->
            <div>
            <b>Namespace: </b>
            djMovile
        </div>
    
    </dt>
<br/>
<br/>
    <dd><p>Canciones para reproduccir.</p>

<p><b>Script de creación para Postgresql</b></p>
<code>
CREATE SEQUENCE seqcancion<br>
INCREMENT 1<br>
START 1;<br>
<br>
CREATE TABLE cancion(<br>
    id integer NOT NULL,<br>
    titulo character varying(100) NOT NULL,<br>
    autor character varying(50) NOT NULL,<br>
    duracion time without time zone NOT NULL,<br>
    caratula character varying(200),<br>
    dedicable boolean NOT NULL DEFAULT true,<br>
    fchultrep timestamp without time zone,<br>
    fchprmpet timestamp without time zone,<br>
CONSTRAINT "PK_Cancion" PRIMARY KEY (id)) ;
</code>

<p><b>Datos de prueba</b></p>
<code>
insert into cancion values (NEXTVAL('seqcancion'),'sin ti no soy nada','amaral','00:04:29');<br>
insert into cancion values (NEXTVAL('seqcancion'),'A Dios le Pido','Juanes','00:03:26');<br>
insert into cancion values (NEXTVAL('seqcancion'),'moriria por vos','amaral','00:03:47');<br>
insert into cancion values (NEXTVAL('seqcancion'),'Gaia','Mägo de Oz','00:11:03');<br>
insert into cancion values (NEXTVAL('seqcancion'),'Toda La Noche En La Calle','amaral','00:03:48');<br>
insert into cancion values (NEXTVAL('seqcancion'),'Te necesito','amaral','00:04:24');<br>
insert into cancion values (NEXTVAL('seqcancion'),'que sera','amaral','00:03:22');<br>
insert into cancion values (NEXTVAL('seqcancion'),'Salir Corriendo','amaral','00:00:00');<br>
insert into cancion values (NEXTVAL('seqcancion'),'estrella de mar','amaral','00:04:22');<br>
insert into cancion values (NEXTVAL('seqcancion'),'Rosa De La Paz','amaral','00:00:00');<br>
insert into cancion values (NEXTVAL('seqcancion'),'No sabe donde va','amaral','00:03:25');<br>
insert into cancion values (NEXTVAL('seqcancion'),'Fotografia','Juanes','00:00:00');<br>
insert into cancion values (NEXTVAL('seqcancion'),'de la noche a la mañana','amaral','00:03:07');<br>
insert into cancion values (NEXTVAL('seqcancion'),'el centro de mis ojos','amaral','00:03:55');<br>
insert into cancion values (NEXTVAL('seqcancion'),'en solo un segundo','amaral','00:08:31');<br>
insert into cancion values (NEXTVAL('seqcancion'),'republicadesanjes','Celtas Cortos','00:00:00');<br>
insert into cancion values (NEXTVAL('seqcancion'),'romancederosabellaydomingo','Celtas Cortos','00:03:49');<br>
insert into cancion values (NEXTVAL('seqcancion'),'sinoveonomecreo','Celtas Cortos','00:03:40');<br>
insert into cancion values (NEXTVAL('seqcancion'),'skaparatenacional','Celtas Cortos','00:03:02');<br>
insert into cancion values (NEXTVAL('seqcancion'),'todoesponerse','Celtas Cortos','00:05:03');<br>
insert into cancion values (NEXTVAL('seqcancion'),'tranquilomajete','Celtas Cortos','00:04:15');<br>
insert into cancion values (NEXTVAL('seqcancion'),'ya esta bien','Celtas Cortos','00:03:04');<br>
insert into cancion values (NEXTVAL('seqcancion'),'el talismán','Rosana','00:03:41');<br>
</code></dd>
    </dl>

<!-- ============================ DIAGRAMS ================================ -->


                                                                                


<!-- ========================================= SUMMARIES ============================================ -->

    <p><hr/></p>
                        

<!-- =========== TAGGED VALUES =========== -->
<!-- =========== CONSTRAINTS =========== -->
    
<!-- ================================================= DETAILS ============================================ -->
        <dt>
<a id="Imeca368fm1130a6e1a2amm7cea_attribute_details"></a>
<table border="1" cellpadding="3" cellspacing="0" width="100%">
<tr bgcolor="#FFCC33" id="TableHeadingColor">
<td valign="top" colspan="2">
<font size="+1">
<table border="0">
<tr>
<td>
<img src="resources/Attribute.gif"/>
</td>
<td valign="middle">
<font size="+1"><b>Attribute  Detail</b></font>
</td>
</tr>
</table>
</font>
</td>
</tr>
</table>
<br/>
<a id="autor">
</a>
<font size="+1"><b>autor</b></font>
<p>
<code>private final 
VARCHAR<b>&nbsp;<b>autor</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Autor de la canción.</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
<hr/>
<br/>
<a id="caratula">
</a>
<font size="+1"><b>caratula</b></font>
<p>
<code>private 
VARCHAR<b>&nbsp;<b>caratula</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Path del gif de la carátula.</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
<hr/>
<br/>
<a id="dedicable">
</a>
<font size="+1"><b>dedicable</b></font>
<p>
<code>private final 
<a href="http://java.sun.com/j2se/1.4.2/docs/api/java/lang/Boolean.html">Boolean</a><b>&nbsp;<b>dedicable</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Si se puede hacer una petición de la canción.</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
<hr/>
<br/>
<a id="duracion">
</a>
<font size="+1"><b>duracion</b></font>
<p>
<code>private final 
<a href="http://java.sun.com/j2se/1.4.2/docs/api/java/util/Time.html">java.util.Time</a><b>&nbsp;<b>duracion</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Duración de la cancion, minutos y segundos</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
<hr/>
<br/>
<a id="fchPrmPet">
</a>
<font size="+1"><b>fchPrmPet</b></font>
<p>
<code>private 
TIMESTAMP<b>&nbsp;<b>fchPrmPet</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Fecha de creación de la primera petición pendiente para la canción.</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
<hr/>
<br/>
<a id="fchUltRep">
</a>
<font size="+1"><b>fchUltRep</b></font>
<p>
<code>private 
TIMESTAMP<b>&nbsp;<b>fchUltRep</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Última vez que se oyo la canción.</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
<hr/>
<br/>
<a id="id">
</a>
<font size="+1"><b>id</b></font>
<p>
<code>private final 
int<b>&nbsp;<b>id</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Clave primaria. Autonumerado. Datos a partir de la secuencia <i>seqcancion</i>.</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
<hr/>
<br/>
<a id="titulo">
</a>
<font size="+1"><b>titulo</b></font>
<p>
<code>private final 
VARCHAR<b>&nbsp;<b>titulo</b></b>
</code>
<div><b>Multiplicity: </b>1</div>
<div><b>Ordering: </b>unspecified</div>
</p>
<dl>
</dl>
<br/><dd><p>Titulo de la canción.</p></dd>
<dl>
</dl>
<dl>
</dl>
<dl>
</dl>
</dt>
        
    </div>
    <HR>
    <center>
                    <a href="Peticion.html">previous</a>
        &nbsp
                <a href="short_TOC.html">TOC</a>
        &nbsp
            <a href="djMovile/associations">next</a>
        </center>
    <hr/>
    <div style="font-size:0.8em;">
Generated with Poseidon for UML<sup><font size='small'>TM</font></sup>.<br/>
Poseidon is a registered trademark of <a href="http://www.gentleware.com" target="nw">Gentleware AG</a> in the USA and other countries.
Copyright 2003-2006 Gentleware AG, Ludwigstr. 12, 20357 Hamburg, Germany. All Rights Reserved.
</div>
    <div style="font-size:0.8em;">
  UML is a trademark or registered trademark of Object Management Group, Inc. in the U.S. and other countries.
</div>
    </body>
</html>
